Daily VOR Messages Export
Introduction
An export that contains information about the messages sent and received for active VORs, including manual VOR enquiries, for a specific day and a specific lease company.
Purpose
Zenith requires an export of VOR messages (sent and received) for active VOR enquiries. This data is used for internal reporting, so the ViSN platform must replicate this export to support Zenith’s existing reporting processes.
File format
Comma Separated Values - *.csv
Records
| Col Position | Field Label | Notes | Data Type | Mandatory |
|---|---|---|---|---|
| A | VOR ID | ViSN enquiry number | integer | Y |
| B | Registration Number | VRM of vehicle associated with the VOR | text | Y |
| C | Message Type ID | Enquiry status. E.g. Checked In, In Progress | text | Y |
| D | Message Type Text | Authorisation status. E.g. Authorisation Requested | text | N |
| E | Message Date/Time | Date timestamp that message was sent or received | date | Y |
| F | Created By | Name of user who sent the (received or sent) message | text | Y |
| G | Message Text | Contents of sent / received message | text max length: 1000 | Y |
| H | Site Name | Name Supplier Site associated with the enquiry | text max length: 250 | Y |
Setup Required
Database Configuration
This export functionality is available only for customers who have the ‘VOR Messages Export’ toggle enabled in the Export Config.
location: /leasecompany/[leaseCompanyId]/exports/settings
attribute: vorMessagesExportEnabled
value: true
Generate Export
A Scheduler should be created cloud scheduler with the following parameters
- Name : GenerateDailyVORMessagesExportCSV
- Description : Daily VOR Message Export Generation
- Region : europe-west2
- Frequency : 30 23 * * *
- TimeZone : Greenwhich Mean Time (GMT)
- Topic : projects/biddirect-2/topics/generateDailyVORMessagesExport
Message body : a JSON object including the following parameters
- leaseCompanyId : id of the lease company that the export is desired to be generated for
- dateTimeStamp : in format yyyy-MMM-dd ex 2025-Nov-05 , when skipped it will default to current date
Status: Accepted
Category: Protected
Authored By: Harish on 05 Nov, 2025